package com.ttms.dao;

import com.ttms.pojo.Sale;
import com.ttms.pojo.Studio;

import java.math.BigDecimal;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.List;

public interface SaleDao {
    public int addSale(Sale sale);

    public int deleteSaleById(Integer id);

    public int updateSale(Sale sale);

    public Sale querySaleById(Integer id);

    public List<Sale> findSaleById(String id);


    public List<Sale> findSaleId(int user_id, Timestamp sale_time, BigDecimal sale_payment, BigDecimal sale_change, int sale_type, int sale_status);

    public List<Sale> querySales();

    Integer queryForPageTotalCount();

    List<Sale> queryForPageItems(int begin, int pageSize);

    Sale querySaleByUserId(int user_id) ;

//    Integer querySaleCountByName(String play_name);


}
